USE [CTEM-DB-v1]
GO

/****** Object:  StoredProcedure [dbo].[Ledger_Create]    Script Date: 02/10/2012 11:20:02 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



-- =============================================
-- Author:		TienDH
-- Create date: 12/05/2011
-- Description:	Get full employee's information
-- =============================================
CREATE PROCEDURE [dbo].[Ledger_Create]
	@Name				nvarchar(MAX),
	@Type				nvarchar(MAX),
	@Kind				bigint,
	@Number				bigint,
	@Person				nvarchar(MAX),
	@Reason				nvarchar(MAX),
	@Method				nvarchar(MAX),
	@Date			    DATETIME,
	@FromAcc            nvarchar(MAX),
	@FromNum			nvarchar(MAX),
	@ToAcc				nvarchar(MAX),
	@ToNum				nvarchar(MAX),
	@FromBank           nvarchar(MAX),
	@ToBank             nvarchar(MAX),
	@Sender             nvarchar(MAX),
	@Taker              nvarchar(MAX),
	@SendDate           nvarchar(MAX)
AS
BEGIN
	INSERT INTO Ledger
	(Name,Type,Number,Person,Reason,Method,Date,Kind,FromAcc,FromNum,ToAcc,ToNum,FromBank,ToBank,Sender,Taker,SendDate)
	VALUES	
	(@Name,@Type,@Number,@Person,@Reason,@Method,@Date,@Kind,@FromAcc,@FromNum,@ToAcc,@ToNum,@FromBank,@ToBank,@Sender,@Taker,@SendDate)
END
SELECT IDENT_CURRENT('Ledger')

GO

